package cn.edu.niit.alienlab.jshttplessonserver.dao;

import cn.edu.niit.alienlab.jshttplessonserver.domain.ActorInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ActorInfoDao {

    /*API5：按影片id获取影片演员列表*/
    @Select("SELECT  ai.*,ma.movie_id FROM movie_actors ma,actor_info ai \n" +
            "WHERE ma.actor_id =ai.actor_id AND ma.movie_id=#{movie_id}")
    public List<ActorInfo> selectActorInfoByMovieId(Integer movie_id);


}
